﻿CREATE TABLE [dbo].[Participants] (
    [ParticipantId] BIGINT NOT NULL,
    [LastName]      NVARCHAR (100) NOT NULL,
    [FirstName]     NVARCHAR (100) NOT NULL,
    [Email]         NVARCHAR (100) NOT NULL,
    CONSTRAINT [PK_Participants] PRIMARY KEY CLUSTERED ([ParticipantId] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Participants]
    ON [dbo].[Participants]([Email] ASC);

